Timestamp

The data used was based on the production of energy in 2021, the latest year available. However, the dataset offers energy data from 1990.

Data source

The source used was data from the ‘Energy Datasheets’ in the European Commission website. It has data about the energy production of many countries, with additional information about the type of energy, such as heat, electricity, and nuclear energy. It also contained more interesting data about greenhouse gas emissions

Link to the source -> Country Datasheets.

Metadata

Actions Performed

1. Export the dataset as a CSV file.
2. Load it in a data frame using pandas (Python library).
3. Deleted the first two sheets, as they weren’t relevant to the question.
4. Retrieved useful rows of every other page and merged them together into a single dataset, specifying those taken during 2021.
5. Re-organized the data frame to have one country per row and the types of energy in the columns.
6. Saved the data frame in a CSV file.
7. Loaded it on Flourish as data of a ‘Tree Map’.
8. Matched the graph parameters to the columns, with the rectangles size representing the value of energy in.
9. Added a drop-down menu filter to choose a specific country.
10. Made additional changes such as color, characters, and popups changes.